IF EXISTS
(
    SELECT 1
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[EPOUpdateOrderStatus]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[EPOUpdateOrderStatus];



IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'TmpDrugH'
          AND COLUMN_NAME = 'OrderId'
)
    ALTER TABLE dbo.TmpDrugH ADD OrderId BIGINT NULL DEFAULT (0);


IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'DrugH'
          AND COLUMN_NAME = 'OrderId'
)
    ALTER TABLE dbo.DrugH ADD OrderId BIGINT NULL DEFAULT (0);


if EXISTS 
 (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EpoTracking]') and xtype='V')
     Drop view [dbo].[vw_EpoTracking]
